pub enum JsonTableColumn {
Named(JsonTableNamedColumn),
ForOrdinality(Ident),
Nested(JsonTableNestedColumn),
}Expand description
A single column definition in MySQL’s JSON_TABLE table valued function.
See
- MySQL’s JSON_TABLE documentation
- Oracle’s JSON_TABLE documentation
- MariaDB’s JSON_TABLE documentation
SELECT *
FROM JSON_TABLE(
'["a", "b"]',
'$[*]' COLUMNS (
name FOR ORDINALITY,
value VARCHAR(20) PATH '$',
NESTED PATH '$[*]' COLUMNS (
value VARCHAR(20) PATH '$'
)
)
) AS jt;Variants§
Named(JsonTableNamedColumn)
A named column with a JSON path
ForOrdinality(Ident)
The FOR ORDINALITY column, which is a special column that returns the index of the current row in a JSON array.
Nested(JsonTableNestedColumn)
A set of nested columns, which extracts data from a nested JSON array.
Trait Implementations§
Source§impl Clone for JsonTableColumn
impl Clone for JsonTableColumn
Source§fn clone(&self) -> JsonTableColumn
fn clone(&self) -> JsonTableColumn
Returns a duplicate of the value. Read more
1.0.0 · Source§fn clone_from(&mut self, source: &Self)
fn clone_from(&mut self, source: &Self)
Performs copy-assignment from source. Read more
Source§impl Debug for JsonTableColumn
impl Debug for JsonTableColumn
Source§impl<'de> Deserialize<'de> for JsonTableColumn
impl<'de> Deserialize<'de> for JsonTableColumn
Source§fn deserialize<__D>(__deserializer: __D) -> Result<Self, __D::Error>where
__D: Deserializer<'de>,
fn deserialize<__D>(__deserializer: __D) -> Result<Self, __D::Error>where
__D: Deserializer<'de>,
where __D: Deserializer<'de>,
Deserialize this value from the given Serde deserializer. Read more
Source§impl Display for JsonTableColumn
impl Display for JsonTableColumn
Source§impl Hash for JsonTableColumn
impl Hash for JsonTableColumn
Source§impl Ord for JsonTableColumn
impl Ord for JsonTableColumn
Source§fn cmp(&self, other: &JsonTableColumn) -> Ordering
fn cmp(&self, other: &JsonTableColumn) -> Ordering
1.21.0 · Source§fn max(self, other: Self) -> Selfwhere
Self: Sized,
fn max(self, other: Self) -> Selfwhere
Self: Sized,
where Self: Sized,
Compares and returns the maximum of two values. Read more
Source§impl PartialEq for JsonTableColumn
impl PartialEq for JsonTableColumn
Source§impl PartialOrd for JsonTableColumn
impl PartialOrd for JsonTableColumn
Source§fn partial_cmp(&self, other: &JsonTableColumn) -> Option<Ordering>
fn partial_cmp(&self, other: &JsonTableColumn) -> Option<Ordering>
This method returns an ordering between self and other values if one exists. Read more
1.0.0 · Source§fn lt(&self, other: &Rhs) -> bool
fn lt(&self, other: &Rhs) -> bool
Tests less than (for self and other) and is used by the < operator. Read more
1.0.0 · Source§fn le(&self, other: &Rhs) -> bool
fn le(&self, other: &Rhs) -> bool
Tests less than or equal to (for self and other) and is used by the
<= operator. Read more
Source§impl Serialize for JsonTableColumn
impl Serialize for JsonTableColumn
Source§impl Visit for JsonTableColumn
impl Visit for JsonTableColumn
Source§impl VisitMut for JsonTableColumn
impl VisitMut for JsonTableColumn
Source§fn visit<V: VisitorMut>(&mut self, visitor: &mut V) -> ControlFlow<V::Break>
fn visit<V: VisitorMut>(&mut self, visitor: &mut V) -> ControlFlow<V::Break>
Mutably visit this node with the provided VisitorMut. Read more
impl Eq for JsonTableColumn
impl StructuralPartialEq for JsonTableColumn
Auto Trait Implementations§
impl Freeze for JsonTableColumn
impl RefUnwindSafe for JsonTableColumn
impl Send for JsonTableColumn
impl Sync for JsonTableColumn
impl Unpin for JsonTableColumn
impl UnwindSafe for JsonTableColumn
Blanket Implementations§
Source§impl<T> BorrowMut<T> for Twhere
T: ?Sized,
impl<T> BorrowMut<T> for Twhere
T: ?Sized,
where T: ?Sized,
Source§fn borrow_mut(&mut self) -> &mut T
fn borrow_mut(&mut self) -> &mut T
Mutably borrows from an owned value. Read more
Source§impl<T> CloneToUninit for Twhere
T: Clone,
impl<T> CloneToUninit for Twhere
T: Clone,
where T: Clone,
impl<T> DeserializeOwned for Twhere
T: for<'de> Deserialize<'de>,
where T: for<'de> Deserialize<'de>,